﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="WebForm3.aspx.cs" Inherits="DONGTAIWANGYE.WebForm3" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .auto-style8 {
            height: 25px;
        }
        .auto-style9 {
            width: 5px;
        }
        .auto-style10 {
            width: 2px;
        }
        .auto-style11 {
            width: 93px;
        }
        .auto-style12 {
            height: 25px;
            width: 93px;
        }
        .auto-style13 {
            width: 92px;
        }
        .auto-style14 {
            height: 25px;
            width: 92px;
        }
        .auto-style15 {
            width: 120px;
        }
        .auto-style16 {
            height: 25px;
            width: 106px;
        }
        .auto-style18 {
            width: 12px;
        }
        .auto-style19 {
            width: 53px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
     <table class="auto-style1" style="margin-left: 0px">
                <tr>
                    <td class="auto-style70"></td>
                    <td class="auto-style103">&nbsp;</td>
                    <td class="auto-style103">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td class="auto-style99"></td>
                    <td class="auto-style19"></td>
                    <td class="auto-style66"></td>
                    <td class="auto-style66"></td>
                    <td class="auto-style9">
                        &nbsp;</td>
                    <td class="auto-style15">
                        &nbsp;</td>
                    <td class="auto-style66"></td>
                    <td class="auto-style95">&nbsp;</td>
                    <td class="auto-style16">&nbsp;</td>
                </tr>
                <tr>
                    <td class="auto-style8" colspan="4">
                        <asp:Button ID="SelectNo" runat="server" Text="按学号查询" OnClick="SelectNo_Click" />
                    </td>
                    <td class="auto-style8" colspan="2">
                        <asp:TextBox ID="txtNo" runat="server"></asp:TextBox>  
                    </td>
                    <td class="auto-style8" colspan="4">
                        <asp:Button ID="SelCol" runat="server" Text="按系别查询" />
                    </td>
                    <td class="auto-style8">
                        <asp:TextBox ID="txtCollege" runat="server" ></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style72" colspan="4">
                        &nbsp;</td>
                    <td class="auto-style72" colspan="2">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3">
                            <Columns>
                                <asp:BoundField DataField="No" HeaderText="No" SortExpression="No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
                                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                                <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                                <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112117ConnectionString %>" SelectCommand="SELECT * FROM [Student] WHERE ([No] = @No)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtNo" Name="No" PropertyName="Text" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </td>
                    <td class="auto-style68" rowspan="5" colspan="3">
                        &nbsp;</td>
                    <td class="auto-style15" rowspan="4">
                        &nbsp;</td>
                    <td class="auto-style18" rowspan="8">
                        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
                            <Columns>
                                <asp:BoundField DataField="No" HeaderText="No" SortExpression="No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
                                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                                <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                                <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112117ConnectionString %>" SelectCommand="SELECT * FROM [Student] WHERE ([College] = @College)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtCollege" Name="College" PropertyName="Text" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style72" colspan="4">
                        &nbsp;</td>
                    <td class="auto-style72" colspan="2">
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="auto-style72" colspan="2">
                        <asp:Button ID="SelectName" runat="server" Text="按姓名查询" OnClick="SelectName_Click" />
                    </td>
                    <td class="auto-style72" colspan="2">
                        &nbsp;</td>
                    <td class="auto-style72" colspan="2">
                        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>  
                    </td>
                </tr>
                <tr>
                    <td class="auto-style72" colspan="2">
                        &nbsp;</td>
                    <td class="auto-style72" colspan="2">
                        &nbsp;</td>
                    <td class="auto-style72" colspan="2" rowspan="3">
                        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
                            <Columns>
                                <asp:BoundField DataField="No" HeaderText="No" SortExpression="No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
                                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                                <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                                <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112117ConnectionString %>" SelectCommand="SELECT * FROM [Student] WHERE ([Name] = @Name)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtName" Name="Name" PropertyName="Text" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style41"></td>
                    <td class="auto-style107">&nbsp;</td>
                    <td class="auto-style107">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td class="auto-style15">
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="auto-style83">&nbsp;</td>
                    <td class="auto-style108">&nbsp;</td>
                    <td class="auto-style108">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td class="auto-style68" rowspan="2" colspan="3">
                        &nbsp;</td>
                    <td class="auto-style15">
                    </td>
                </tr>
                <tr>
                    <td class="auto-style39" rowspan="2">&nbsp;</td>
                    <td class="auto-style109" rowspan="2">&nbsp;</td>
                    <td class="auto-style109" rowspan="2">&nbsp;</td>
                    <td rowspan="2">&nbsp;</td>
                    <td class="auto-style101" colspan="2">&nbsp;</td>
                    <td class="auto-style15">
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="auto-style101" colspan="2">&nbsp;</td>
                    <td class="auto-style68" rowspan="2" colspan="3">
                        &nbsp;</td>
                    <td class="auto-style15">
                    </td>
                </tr>
                <tr>
                    <td class="auto-style79"></td>
                    <td class="auto-style110">&nbsp;</td>
                    <td class="auto-style110">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td class="auto-style101" colspan="2">&nbsp;</td>
                    <td class="auto-style15">
                        &nbsp;</td>
                    <td class="auto-style18">
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="auto-style73">&nbsp;</td>
                    <td class="auto-style111">&nbsp;</td>
                    <td class="auto-style111">&nbsp;</td>
                    <td>&nbsp;</td>
                    <td class="auto-style102">
                        &nbsp;</td>
                    <td class="auto-style19">
                        &nbsp;</td>
                    <td class="auto-style69" colspan="3">&nbsp;</td>
                    <td class="auto-style15">  
                    </td>
                    <td class="auto-style47">  
                    </td>
                </tr>
                </table>
</asp:Content>
